﻿<%@ Page Title="" Language="C#" MasterPageFile="MasterPage.master" AutoEventWireup="true" CodeFile="InscritosCursos.aspx.cs" Inherits="_InscritosCursos" %>
<%@ Register assembly="DevExpress.Web.v9.1, Version=9.1.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxTabControl" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v9.1, Version=9.1.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxClasses" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.1, Version=9.1.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dxe" %>

<%@ Register assembly="DevExpress.Web.v9.1" namespace="DevExpress.Web.ASPxTabControl" tagprefix="dxtc" %>
<%@ Register assembly="DevExpress.Web.v9.1" namespace="DevExpress.Web.ASPxClasses" tagprefix="dxw" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
    body 
    {
        font: 12px Tahoma, Arial;
    }
    span 
    {
        font: 11px Tahoma, Arial;
    }
    input[type=text], select
    {
        padding: 2px;
    }
    
    .tabela td, th
    {
        padding: 3px;
    }
    .style1
    {
        height: 22px;
    }

        .style7
        {
            height: 38px;
        }

        .style8
        {
            width: 225px;
            height: 32px;
        }

        .style9
        {
            height: 16px;
        }

        .style10
        {
            width: 70px;
        }

    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<%--<script type="text/javascript">muda(inscritos, '#0C5C7E');</script>--%>

    <h1>Inscritos x Qualificações</h1>
            <table style="width: 100%; margin-top: 10px;">
                <tr>
                    <td class="style9" colspan="3">
            <strong>1 - Pesquise por CPF ou Nome (digite as iniciais do nome) (</strong><asp:HyperLink 
                            ID="HyperLink1" runat="server" NavigateUrl="senac.aspx">senac</asp:HyperLink>
                        )</td>
                </tr>
                <tr>
                    <td class="style9">
                        <strong>CPF</strong></td>
                    <td class="style9">
                        <strong>Nome</strong></td>
                    <td class="style9">
                        </td>
                </tr>
                <tr>
                    <td class="style1">
                        <asp:TextBox ID="txtCPF" runat="server" MaxLength="15" Width="150px"></asp:TextBox>
                    </td>
                    <td class="style1">
                        <asp:TextBox ID="txtNome" runat="server" MaxLength="50" Width="220px"></asp:TextBox>
                    </td>
                    <td class="style1">
                        <asp:ImageButton ID="btnPesquisar" runat="server" 
                            ImageUrl="../figuras/bPesquisar.gif" 
                            onclick="btnPesquisar_Click" />
                    </td>
                </tr>
                <tr>
                    <td colspan="3">&nbsp;
                        </td>
                </tr>
                <tr>
                    <td colspan="3">
                       <strong>2 - Listagem de inscritos</strong><br />
                       <span>
                        Selecione agora o inscrito, o curso que ele fez e depois clique em cadastrar.</span></td>
                </tr>
                <tr>
                    <td colspan="3">
                        </td>
                </tr>
                <tr>
                    <td colspan="3">
                        <table style="width:100%;">
                            <tr>
                                <td class="style10">
                                    Candidato:</td>
                                <td>
                        <asp:DropDownList ID="ddInscritos" runat="server" AutoPostBack="True" 
                            DataSourceID="dsInscritos" DataTextField="NomeAluno" DataValueField="CPF" 
                            AppendDataBoundItems="True" ValidationGroup="gInserir" 
                            onselectedindexchanged="ddInscritos_SelectedIndexChanged">
                            <asp:ListItem></asp:ListItem>
                        </asp:DropDownList>
                        <asp:SqlDataSource ID="dsInscritos" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                            DataSourceMode="DataReader" 
                            ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>">
                        </asp:SqlDataSource>&nbsp;<asp:Button ID="btnDisponivel" runat="server" Text="Button" Visible="false" EnableViewState="false" onclick="btnDisponivel_Click" />
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                </table>

				<br />

                <dx:ASPxPageControl ID="ASPxPageControl1" runat="server" ActiveTabIndex="0" TabSpacing="3px" ImageFolder="~/App_Themes/Aqua/{0}/" LoadingPanelText="" Width="100%">
                <ContentStyle>
                    <Border BorderColor="#AECAF0" BorderStyle="Solid" BorderWidth="1px" />
                </ContentStyle>
                <TabPages>
                    <dx:TabPage Text="Qualificações">
                    <ContentCollection>
                    <dx:ContentControl ID="ContentControl1" runat="server">
                    
                    
                    
                <table style="width:100%">
                <tr>
                    <td class="style7">
                        <table style="width:100%;">
                            <tr>
                                <td class="style10">
                                    <strong>Curso:&nbsp;</strong></td>
                                <td>
                        <asp:DropDownList ID="ddCursos" runat="server" AutoPostBack="True" 
                            DataSourceID="dsCursos" DataTextField="Curso" DataValueField="Codigo" 
                            AppendDataBoundItems="True" ValidationGroup="gInserir">
                            <asp:ListItem></asp:ListItem>
                        </asp:DropDownList>
                                    <asp:SqlDataSource ID="dsCursos" runat="server" 
                                        ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                                        ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                                        SelectCommand="SELECT (Cast(CodCurso as varchar)+';'+Cast(CodCategoria as varchar)) as Codigo, Curso FROM CamaraCursos ORDER BY Curso">
                                    </asp:SqlDataSource>
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:ImageButton ID="btnCadastrar" runat="server" 
                            ImageUrl="../figuras/bCadastrar.gif" 
                            onclick="btnCadastrar_Click" ValidationGroup="gInserir" />
                        <asp:RequiredFieldValidator ID="RV2" runat="server" 
                            ControlToValidate="ddCursos" Display="None" ErrorMessage="Selecione o curso" 
                            ValidationGroup="gInserir"></asp:RequiredFieldValidator>
                        <asp:ValidationSummary ID="VS1" runat="server" ShowMessageBox="True" 
                            ShowSummary="False" ValidationGroup="gInserir" />
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Label ID="lblMensagemQualificacao" runat="server" EnableViewState="False" 
                            ForeColor="Blue"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td>
                    &nbsp;
                    </td>
                </tr>
                <tr>
                    <td>
                        <img alt="Qualificações do inscrito" class="style8" 
                            src="../figuras/gQualificacoesInscritos.gif" /></td>
                </tr>
                <tr>
                    <td>
                <asp:GridView runat="server" AllowPaging="True" 
                AutoGenerateColumns="False" CellPadding="4" 
                EnableModelValidation="True" GridLines="None" DataSourceID="dsInscritosTurmas" 
                ForeColor="#333333" Width="100%" ID="gridCursos" 
                                                DataKeyNames="cpf,codcurso" CssClass="tabela" 
                    onrowcommand="gridCursos_RowCommand">
<AlternatingRowStyle BackColor="White" ForeColor="#284775"></AlternatingRowStyle>
                                                <Columns>
                                                    <asp:BoundField DataField="Curso" HeaderText="Curso" >
                                                    <ControlStyle CssClass="tabela" />
                                                    <HeaderStyle HorizontalAlign="Left" />
                                                    <ItemStyle HorizontalAlign="Left" />
                                                    </asp:BoundField>
                                                    <asp:BoundField DataField="Categoria" HeaderText="Categoria" >
                                                    <HeaderStyle HorizontalAlign="Left" />
                                                    <ItemStyle HorizontalAlign="Left" />
                                                    </asp:BoundField>
                                                    <asp:TemplateField ShowHeader="False">
                                                        <ItemTemplate>
                                                            <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 
                                                                CommandName="Delete" CommandArgument='<%# Eval("CodCategoria") %>' 
                                                                onclientclick="return confirm('Deseja excluir o curso desse inscrito?')" 
                                                                Text="Excluir"></asp:LinkButton>
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                </Columns>

<EditRowStyle BackColor="#999999"></EditRowStyle>

<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></FooterStyle>

<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></HeaderStyle>

<PagerStyle HorizontalAlign="Center" BackColor="#284775" ForeColor="White"></PagerStyle>

<RowStyle BackColor="#F7F6F3" ForeColor="#333333"></RowStyle>

<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333"></SelectedRowStyle>
</asp:GridView>

                                            <asp:SqlDataSource ID="dsInscritosTurmas" 
                runat="server" ConnectionString="<%$ ConnectionStrings:conexao_intranet %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet.ProviderName %>" 
                SelectCommand="SELECT CamaraInscritosCursos.CPF, CamaraInscritosCursos.CodCurso, CamaraCursos.Curso, CamaraCursos.CodCategoria, CamaraCategorias.Categoria FROM CamaraInscritosCursos INNER JOIN CamaraCursos ON CamaraInscritosCursos.CodCurso = CamaraCursos.CodCurso INNER JOIN CamaraCategorias ON CamaraCursos.CodCategoria = CamaraCategorias.CodCategoria WHERE (CamaraInscritosCursos.CPF = @cpf) ORDER BY Curso"
                DeleteCommand="DELETE FROM CamaraInscritosCursos WHERE CodCurso=@codCurso AND CPF=@cpf">
                                                <SelectParameters>
                                                    <asp:Parameter Name="cpf" />
                                                </SelectParameters>
                                                <DeleteParameters>
                                                    <asp:Parameter Name="CodCurso" Type="Int32" />
                                                    <asp:Parameter Name="CPF" Type="String" />
                                                </DeleteParameters>

            </asp:SqlDataSource>

                                            </td>
                </tr>
</table>
                    
                    
                    

                    </dx:ContentControl>
                    </ContentCollection>
                    </dx:TabPage>

                    <dx:TabPage Text="Experiência Profissional">
                    <ContentCollection>
                    <dx:ContentControl ID="ContentControl2" runat="server">




            <table style="width:100%">
                <tr>
                    <td>


                                            <table style="width:400px;">
                            <tr>
                                <td class="style1">
                                    <strong>Segmento:</strong></td>
                                <td>
                                    <asp:DropDownList ID="ddSegmento" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddSegmentos_SelectedIndexChanged">
                                        <asp:ListItem></asp:ListItem>
                                        <asp:ListItem Value="adm">ADMINISTRATIVO</asp:ListItem>
                                        <asp:ListItem Value="loj">LOJISTA</asp:ListItem>
                                        <asp:ListItem Value="ope">OPERAÇÕES/INFRAESTRUTURA</asp:ListItem>
                                        <asp:ListItem Value="aeb">ALIMENTOS E BEBIDAS</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class="style1">
                                    <strong>Experiência:</strong></td>
                                <td>
                                    <asp:DropDownList ID="ddFuncoes" runat="server" DataSourceID="dsFuncoes" 
                                        DataTextField="Funcao" DataValueField="CodFuncao" 
                                        AppendDataBoundItems="True">
                                    </asp:DropDownList>
                                    <asp:SqlDataSource ID="dsFuncoes" runat="server" 
                                        ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                                        ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>">
                                        <SelectParameters>
                                            <asp:ControlParameter ControlID="ddSegmento" Name="segmento" 
                                                PropertyName="SelectedValue" />
                                        </SelectParameters>
                                    </asp:SqlDataSource>
                                </td>
                            </tr>
                            <tr>
                                <td class="style1">
                                    <strong>Local:</strong></td>
                                <td>
                                    <asp:TextBox ID="txtLocal" runat="server" MaxLength="100" Width="300px"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class="style1">
                                    <strong>Tempo:</strong></td>
                                <td>
                                    <asp:TextBox ID="txtTempo" runat="server" MaxLength="20"></asp:TextBox>
                                &nbsp;<span>(ex: 2 anos e 5 meses)</span></td>
                            </tr>
                        </table>



                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:ImageButton ID="btnCadastrarExperiencia" runat="server" 
                            ImageUrl="../figuras/bCadastrar.gif" 
                            onclick="btnCadastrarExperiencia_Click" ValidationGroup="gExperiencia" 
                            PostBackUrl="#qualificacoes" /> 
                        <asp:Label ID="lblCadastraFuncao" runat="server" Text="" EnableViewState="false" Visible="false"></asp:Label>
                        <asp:RequiredFieldValidator ID="RV5" runat="server" ControlToValidate="ddFuncoes" 
                            Display="None" ErrorMessage="Informe a experiência" 
                            ValidationGroup="gExperiencia"></asp:RequiredFieldValidator>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtLocal" 
                            Display="None" ErrorMessage="Informe o local" 
                            ValidationGroup="gExperiencia"></asp:RequiredFieldValidator>
                        <asp:RequiredFieldValidator ID="RV7" runat="server" ControlToValidate="txtTempo" 
                            Display="None" ErrorMessage="Informe o tempo" 
                            ValidationGroup="gExperiencia"></asp:RequiredFieldValidator>
                        <asp:ValidationSummary ID="VS3" runat="server" ShowMessageBox="True" 
                            ShowSummary="False" ValidationGroup="gExperiencia" />
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Label ID="lblMensagemExperiencia" runat="server" EnableViewState="False" 
                            ForeColor="Blue"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td>
                    &nbsp;
                    </td>
                </tr>

                <tr>
                    <td>
                        <img alt="Experiência profissional" class="style8" 
                            src="../figuras/gExperienciaProfissional.gif" /></td>
                </tr>

                <tr>
                    <td>
                <asp:GridView runat="server" AllowPaging="True" 
                AutoGenerateColumns="False" CellPadding="4" 
                EnableModelValidation="True" GridLines="None" DataSourceID="dsInscritosExperiencias" 
                ForeColor="#333333" Width="100%" ID="gridExperiencias" 
                                                DataKeyNames="cpf,codexperiencia" 
                    CssClass="tabela" onrowcommand="gridExperiencias_RowCommand">
<AlternatingRowStyle BackColor="White" ForeColor="#284775"></AlternatingRowStyle>
                                                <Columns>
                                                    <asp:BoundField DataField="Funcao" HeaderText="Experiência" >
                                                    <ControlStyle CssClass="tabela" />
                                                    <HeaderStyle HorizontalAlign="Left" />
                                                    <ItemStyle HorizontalAlign="Left" />
                                                    </asp:BoundField>
                                                    <asp:BoundField DataField="Tempo" HeaderText="Tempo" >
                                                    <ControlStyle CssClass="tabela" />
                                                    <HeaderStyle HorizontalAlign="Left" />
                                                    <ItemStyle HorizontalAlign="Left" />
                                                    </asp:BoundField>
                                                    <asp:TemplateField ShowHeader="False">
                                                        <ItemTemplate>
                                                            <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" 
                                                                CommandName="Delete" 
                                                                onclientclick="return confirm('Deseja excluir a experiência do inscrito?')" 
                                                                Text="Excluir"></asp:LinkButton>
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                </Columns>

<EditRowStyle BackColor="#999999"></EditRowStyle>

<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></FooterStyle>

<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></HeaderStyle>

<PagerStyle HorizontalAlign="Center" BackColor="#284775" ForeColor="White"></PagerStyle>

<RowStyle BackColor="#F7F6F3" ForeColor="#333333"></RowStyle>

<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333"></SelectedRowStyle>
</asp:GridView>

                                            <asp:SqlDataSource ID="dsInscritosExperiencias" 
                runat="server" ConnectionString="<%$ ConnectionStrings:conexao_intranet %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet.ProviderName %>" 
                SelectCommand="SELECT CamaraInscritosExperiencias.CodExperiencia, CamaraInscritosExperiencias.CPF, CamaraFuncoes.Funcao, CamaraInscritosExperiencias.Tempo
FROM CamaraFuncoes INNER JOIN CamaraInscritosExperiencias ON CamaraFuncoes.CodFuncao = CamaraInscritosExperiencias.CodFuncao WHERE (CamaraInscritosExperiencias.CPF = @cpf)"
                DeleteCommand="DELETE FROM CamaraInscritosExperiencias WHERE CodExperiencia=@codExperiencia AND CPF=@cpf">
                                                <SelectParameters>
                                                    <asp:Parameter Name="cpf" />
                                                </SelectParameters>
                                                <DeleteParameters>
                                                    <asp:Parameter Name="CodExperiencia" Type="Int32" />
                                                    <asp:Parameter Name="CPF" Type="String" />
                                                </DeleteParameters>

            </asp:SqlDataSource>

                                            </td>
                </tr>
                </table>




                    </dx:ContentControl>
                    </ContentCollection>
                    </dx:TabPage>

                    <dx:TabPage Text="Outras capacitações">
                    <ContentCollection>
                    <dx:ContentControl ID="ContentControl3" runat="server">



                <table style="width:100%">
                <tr>
                    <td>
                        <table style="width:80%;">
                            <tr>
                                <td>
                                    <strong>Curso:</strong></td>
                                <td>
                        <asp:TextBox ID="txtCurso" runat="server" MaxLength="50" Width="250px" 
                                        ValidationGroup="gOutrasCap"></asp:TextBox>
                                </td>
                                <td>
                                    <strong>&nbsp;CH:&nbsp;</strong></td>
                                <td>
                                    <asp:TextBox ID="txtCH" runat="server" MaxLength="3" 
                                        ValidationGroup="gOutrasCap" Width="30px"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td><strong>Instituição:&nbsp;</strong></td>
                                <td colspan="3"><asp:TextBox ID="txtInstituicao" runat="server" MaxLength="100" Width="250px" 
                                        ValidationGroup="gOutrasCap"></asp:TextBox></td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:ImageButton ID="btnCadastrarOutrasCap" runat="server" 
                            ImageUrl="../figuras/bCadastrar.gif" 
                            onclick="btnCadastrarOutrasCap_Click" ValidationGroup="gOutrasCap" 
                            PostBackUrl="#qualificacoes" />
                        <asp:RequiredFieldValidator ID="RV3" runat="server" ControlToValidate="txtCurso" 
                            Display="None" ErrorMessage="Informe o curso" ValidationGroup="gOutrasCap"></asp:RequiredFieldValidator>
                        <asp:RequiredFieldValidator ID="RV4" runat="server" ControlToValidate="txtCH" 
                            Display="None" ErrorMessage="Informe a carga horária" 
                            ValidationGroup="gOutrasCap"></asp:RequiredFieldValidator>
                        <asp:RequiredFieldValidator ID="RV6" runat="server" ControlToValidate="txtInstituicao" 
                            Display="None" ErrorMessage="Informe a instituição" 
                            ValidationGroup="gOutrasCap"></asp:RequiredFieldValidator>
                        <asp:CompareValidator ID="CV1" runat="server" ControlToValidate="txtCH" 
                            Display="None" ErrorMessage="A carga horária deve conter apenas números" Operator="DataTypeCheck" 
                            Type="Integer" ValidationGroup="gOutrasCap"></asp:CompareValidator>
                        <asp:ValidationSummary ID="VS2" runat="server" ShowMessageBox="True" 
                            ShowSummary="False" ValidationGroup="gOutrasCap" />
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Label ID="lblMensagemOutras" runat="server" EnableViewState="False" 
                            ForeColor="Blue"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td>
                    &nbsp;
                    </td>
                </tr>
               <tr>
                    <td>
                        <img alt="Qualificações do inscrito" class="style8" 
                            src="../figuras/gOutrasCapacitacoes.gif" /></td>
                </tr>
 
                <tr>
                    <td>
                <asp:GridView runat="server" AllowPaging="True" 
                AutoGenerateColumns="False" CellPadding="4" 
                EnableModelValidation="True" GridLines="None" DataSourceID="dsInscritosOutrasCapacitacoes" 
                ForeColor="#333333" Width="100%" ID="gridOutrasCapacitacoes" 
                                                DataKeyNames="cpf,codcapacitacao" 
                    CssClass="tabela" onrowcommand="gridOutrasCapacitacoes_RowCommand">
<AlternatingRowStyle BackColor="White" ForeColor="#284775"></AlternatingRowStyle>
                                                <Columns>
                                                    <asp:BoundField DataField="Curso" HeaderText="Curso" >
                                                    <ControlStyle CssClass="tabela" />
                                                    <HeaderStyle HorizontalAlign="Left" />
                                                    <ItemStyle HorizontalAlign="Left" />
                                                    </asp:BoundField>
                                                    <asp:BoundField DataField="Instituicao" HeaderText="Instituição" >
                                                    <ControlStyle CssClass="tabela" />
                                                    <HeaderStyle HorizontalAlign="Left" />
                                                    <ItemStyle HorizontalAlign="Left" />
                                                    </asp:BoundField>

                                                    <asp:BoundField DataField="CH" HeaderText="CH" >
                                                    <HeaderStyle HorizontalAlign="Center" />
                                                    <ItemStyle HorizontalAlign="Center" />
                                                    </asp:BoundField>
                                                    <asp:TemplateField ShowHeader="False">
                                                        <ItemTemplate>
                                                            <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 
                                                                CommandName="Delete" 
                                                                onclientclick="return confirm('Deseja excluir o curso desse inscrito?')" 
                                                                Text="Excluir"></asp:LinkButton>
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                </Columns>

<EditRowStyle BackColor="#999999"></EditRowStyle>

<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></FooterStyle>

<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></HeaderStyle>

<PagerStyle HorizontalAlign="Center" BackColor="#284775" ForeColor="White"></PagerStyle>

<RowStyle BackColor="#F7F6F3" ForeColor="#333333"></RowStyle>

<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333"></SelectedRowStyle>
</asp:GridView>

                                            <asp:SqlDataSource ID="dsInscritosOutrasCapacitacoes" 
                runat="server" ConnectionString="<%$ ConnectionStrings:conexao_intranet %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet.ProviderName %>" 
                SelectCommand="SELECT     CodCapacitacao, CPF, Curso, CH, Instituicao
FROM         CamaraInscritosOutrasCapacitacoes
WHERE     (CPF = @cpf)"
                
                    DeleteCommand="DELETE FROM CamaraInscritosOutrasCapacitacoes WHERE CodCapacitacao=@codCapacitacao AND CPF=@cpf">
                                                <SelectParameters>
                                                    <asp:Parameter Name="cpf" />
                                                </SelectParameters>
                                                <DeleteParameters>
                                                    <asp:Parameter Name="CodCapacitacao" Type="Int32" />
                                                    <asp:Parameter Name="CPF" Type="String" />
                                                </DeleteParameters>

            </asp:SqlDataSource>
                    </td>
                </tr>
                </table>



                    </dx:ContentControl>
                    </ContentCollection>
                    </dx:TabPage>


                </TabPages>
                </dx:ASPxPageControl>


</asp:Content>